SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419198 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419198 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130074,102764,155208,625592,635636,916391,897513,857444,55153,72232,679574,280403,913026,849175,830267,399931,717867,55871,1035538,4804,399335,323196,342892,170321,942668,226628,433621,38539,356578,559217,92242,679193,864585,1007672,535467,798025,276984,300134,864054,251415,632053,463108,860291,201153,418650,260447,1013547,1001684,775344,287804,889251,966064,302252,567998,526636,196272,450343,400976,1047667,172259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]