SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 130104 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 130104 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201132,547603,968210,75216,302532,343273,642045,402042,983053,793125,92180,792969,849811,38796,524038,61449,62910,56787,448377,56688,510840,721717,476429,591392,393188,509571,315747,759247,812855,376923,524512,319057,303997,528612,288840,947626,7109,766456,532742,3808,847902,11045,148953,847488,194351,749116,1697,486158,308555,99786,505120,897809,57745,610259,927166,383259,43892,205835,750510,1010166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 130104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 130104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]