SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 688314 LIMIT 1 [ RunTime:0.001355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 688314 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953401,480551,52231,740451,1010478,158972,1029634,935552,201660,453050,682963,680167,213990,762957,492151,20029,841411,851498,759711,620228,389481,311097,163567,574639,884460,520580,410217,489277,960435,778249,34339,964783,709490,63556,759396,707072,827246,42514,966519,829603,789259,903131,136346,85412,111553,1033646,725799,209539,290182,996776,553989,727457,349876,138819,942168,1041829,767809,330148,17350,761391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 688314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 688314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]