SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007613 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007613 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709340,1000841,1010535,22223,150197,631501,924148,419011,900193,409746,29140,178290,585810,692049,479287,147238,889040,578873,294506,11704,528632,68353,589560,478972,949206,864386,201729,783407,972199,680531,1047336,289602,790460,116022,332552,425373,108566,390783,553455,465233,1048594,65065,312766,592771,706966,754738,615582,305871,359741,481329,925778,29701,380188,72373,611472,236162,593327,285385,644983,998069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]