SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382009 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382009 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715653,804750,722898,1017026,910149,351118,264695,368145,727122,933040,984200,602574,69497,19053,559350,415661,205096,638572,427900,421677,1045273,75737,257740,489266,295597,795497,215171,577608,989220,696801,442131,401665,702652,167627,549595,142637,483244,77692,652233,23559,122058,252035,259118,348386,401160,132751,712662,1047824,667755,718924,815871,246672,938098,576228,426611,427978,343657,311011,888798,11132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]