SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802713 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802713 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678501,21682,981290,319523,535204,427750,127546,39277,1020523,743079,5886,994174,610915,130007,894062,787407,884321,208267,953788,768222,73773,813491,466363,629446,249000,804377,1025560,252629,212538,952583,70421,565279,601794,221665,937939,534442,100044,211115,856378,780130,551981,399001,530672,387911,96761,77879,319468,317213,363712,201461,797633,949127,301331,812858,142239,588793,590327,373460,35818,579229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]