SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017908 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017908 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92191,864668,720542,983780,77305,901043,205154,32522,709336,103739,428296,279196,917238,243556,39577,136457,502896,176202,20298,473468,80274,866177,922334,481240,599779,310437,590030,881767,947867,14507,835448,693547,791563,1005300,456363,794824,449699,772250,660942,793888,717885,517340,577351,171787,356300,208308,951128,241305,389993,429653,979960,292162,530945,1004135,93478,202751,960855,736853,790603,18255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]