SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440401 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440401 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334930,981415,536414,332229,508228,846981,151779,271380,293500,815643,289990,175705,130566,302242,137863,8466,230474,699408,340615,289661,527418,601799,981722,987595,2843,38566,8873,674209,714968,572322,599714,480915,964243,950509,400507,897520,518137,1725,632077,943187,290938,44662,799152,97493,678609,519049,598581,527320,352111,830190,812297,324246,986903,173755,231788,657562,528322,12308,144354,472207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]