SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691610 LIMIT 1 [ RunTime:0.002616s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691610 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660531,459100,410983,473943,612979,163224,462484,748428,313042,857350,480241,200155,137851,1000334,428804,516103,866111,247446,261344,1038529,57040,297396,483711,1033447,286037,640406,739470,147260,954788,752605,277108,5934,641381,47279,649480,734743,487834,1042462,772382,14861,77616,312717,889091,360167,425132,795003,565120,185491,489887,684236,45463,802173,1040772,620933,593531,641107,553375,711669,447890,527660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]