SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001154 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001154 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126749,908346,1021074,184369,270848,537484,519883,1030030,657589,1006807,115405,316500,1002406,514753,37436,578487,11094,323333,89572,890443,500940,539997,196851,55320,1023082,342938,909319,942267,934069,946650,559515,265094,959292,754747,909804,485124,466390,72210,377329,656274,1032275,39700,979941,649158,158746,997812,336771,148282,921742,256220,107756,547838,563357,484048,1022973,497641,382909,746770,546763,416294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001902s ]