SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338071 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338071 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438231,863162,492604,235371,40740,914146,24145,718412,857119,900052,751901,965084,687142,610573,562572,117014,986150,567799,619746,339622,399374,141048,316718,599147,1037898,843825,72360,122770,56362,152046,185918,225365,247800,223933,699019,342707,322873,335266,194376,506503,649581,202501,190142,727037,858496,428805,21259,914111,347975,689663,733050,355553,761028,774767,8813,405606,698054,45272,799922,545911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]