SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511368 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511368 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70382,751216,638052,1040990,1026570,103689,999214,428713,709396,891264,950919,505513,291625,100891,805724,499334,584014,235711,349972,412070,810320,727144,320991,367142,520342,450486,44569,410050,222589,616954,429716,160526,390723,231731,905693,404079,246055,272989,372019,31512,938778,181544,526972,708101,500624,666276,333970,446652,1024574,964342,10894,963431,462103,96299,492827,660729,509044,153304,119953,718507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]