SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008678 LIMIT 1 [ RunTime:0.001056s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008678 [ RunTime:0.002839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470362,407791,376794,174531,164382,991997,842112,166862,562133,258505,901024,470385,85722,320535,495876,1048829,605853,579894,1043674,720403,19326,560116,902683,4576,645770,403901,122591,107480,67156,840583,972389,115896,690871,287443,133295,729871,370430,481609,584302,188917,1009624,761831,79820,126443,37496,829816,671700,472790,569443,160529,972113,1002129,352732,79833,347725,946632,465805,362587,737727,934546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]