SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290509 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290509 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814260,35096,622626,772608,1027488,90426,666158,734051,34410,526348,959247,861839,413764,1047165,4862,771448,349052,470346,958813,740872,876868,42491,310159,457124,714248,139475,173601,882727,157809,685339,457093,501850,137694,111284,293987,725967,564389,314252,982481,109516,851726,341018,190444,944881,343976,278221,1047481,855488,496890,653740,853955,526027,622878,993804,728632,976742,785774,951416,478334,304232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]