SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495470 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495470 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643086,811835,76507,223995,298904,852748,165288,571192,202585,5432,579429,206954,723666,574339,399160,480517,181270,567694,105483,261007,345129,237639,787972,115761,943783,430723,462503,739233,495730,2586,912945,239873,783736,156966,651022,513574,144276,451205,856879,955406,907938,35989,508727,767293,102300,830932,219203,70274,726690,328012,627651,552880,971400,13606,918787,385553,345751,1038567,743002,687740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]