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` = 1014344 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014344 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33220,647596,854116,223660,613073,205428,353952,25026,239541,185921,524505,370470,424647,124228,604581,1002361,468958,352907,1013604,385115,468654,167206,469554,156743,218615,190253,318146,616110,1028746,797498,703043,483201,194915,365567,439816,851996,970503,883279,791903,1019732,814118,410315,814980,710843,217376,504484,829433,378190,306508,765885,626987,594382,580103,43284,264266,545566,988852,80268,632929,327312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003212s ]