SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509383 LIMIT 1 [ RunTime:0.002494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509383 [ RunTime:0.005358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861078,209755,587789,458191,803518,128552,819652,123649,1036595,604836,587463,200891,371238,967601,591228,929883,475089,342772,190967,388406,481754,716810,912634,56802,176842,435572,1031767,883430,18318,2666,662952,948141,154225,304127,1023610,717027,449454,723218,495619,1030505,517881,920559,536964,146647,467776,717827,952646,959494,927233,109169,523239,240209,976424,129028,733751,19479,280719,915408,891419,382535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]