SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042284 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042284 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509863,693448,707762,898404,630849,1044833,359345,847053,851886,792774,571275,1020427,335156,167196,751348,279492,662607,475992,475402,190194,126398,466438,119955,795981,335910,241743,995219,4200,323666,292909,77648,929943,396198,782618,903966,521900,845277,918341,582513,992469,261078,164495,26537,435862,891528,626789,531008,109340,288855,706957,38513,222349,202517,308893,864949,733390,830573,890357,757568,698191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]