SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013340 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013340 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27052,458739,215035,608519,345016,241355,285695,37474,128823,597749,296208,663953,954115,806190,468722,257350,346798,263620,645558,574743,646400,384748,299039,794337,970797,950479,446766,413419,577861,796460,173002,249245,558875,878797,996892,222919,897224,54182,304300,146047,719187,209999,298984,359606,358167,809483,887459,158460,9175,868761,396788,882052,909884,360045,183753,541181,686703,508608,985712,727193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]