SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417564 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417564 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031681,642071,99226,434268,998605,303948,542539,301969,725794,35478,799179,740286,521343,335612,793147,55953,400723,488444,581741,760311,226389,890254,853692,255009,410877,502542,826486,356454,114463,1043440,786656,300241,34745,524054,524509,380422,657076,646729,190626,858144,115907,879222,281525,842660,182260,809428,666838,887429,113622,398355,760857,114850,532606,176368,44938,1026229,328871,343833,497503,279734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]