SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330916 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330916 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810354,325309,171954,356044,401837,377827,408988,975955,1039812,236100,9676,632457,323927,743563,531364,11857,220366,205408,930704,1031310,50651,7554,798602,398621,929949,374268,209741,143233,283660,860049,578363,601362,420311,273082,990673,732770,568552,400776,236499,789174,402919,223020,169705,639749,494258,897780,923980,434398,478916,238163,438311,162736,563541,391897,908933,118271,480253,301342,674627,90006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]