SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031039 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031039 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173038,370221,111597,134114,457800,781339,745904,158576,884083,735454,279014,950249,1030462,193576,477423,196106,55813,347470,792679,713073,164111,2488,435085,601067,469732,234729,838096,144773,131037,389305,95893,929992,814445,679526,701752,634060,53114,356057,169015,623815,791866,655278,786573,585069,193434,487069,197284,481137,308311,717926,822206,81779,455831,75143,177349,658390,240596,819925,213615,767767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]