SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971153 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971153 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721825,949800,521626,445057,791298,400452,112687,678017,398738,266862,658544,1001140,50074,720248,367934,819945,347529,713631,1044258,552003,761061,1023128,1007559,963571,101582,515469,57150,296987,926903,829235,427895,1036191,348036,902448,38988,989864,110340,747870,251996,695687,734102,196722,63155,700705,511320,550513,725899,868359,620015,1047456,604901,134861,1010314,595433,1039292,1035889,771260,129169,795664,354198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]