SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532418 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532418 [ RunTime:0.003701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245464,281879,628377,939604,696440,334782,782417,166573,731128,636460,227778,869039,188961,1013837,845710,784346,1040063,628392,213852,655550,397689,670033,56751,706549,229671,893367,214445,31529,124922,710127,651702,1021420,652829,384021,470750,101506,259204,461893,711357,712907,133154,86205,555444,447051,681948,1022576,98973,847876,15337,19226,448233,592667,515291,189611,611462,321510,903832,1023204,770173,260455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]