SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405091 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405091 [ RunTime:0.003445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85886,815167,686176,817135,687187,3108,496987,24929,331894,75621,968851,636612,985706,974687,67934,345357,565311,383243,532724,106765,149029,112349,782056,979800,823525,716969,204671,481073,136113,321728,78636,838152,616773,111230,426267,851610,1006502,521897,514395,263325,274993,430584,935051,475672,819453,599389,270282,200111,617951,525353,238508,555703,128906,464054,771101,563678,657895,569804,925551,185894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]