SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573875 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573875 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555963,156279,489568,103155,123460,18375,446155,281520,474775,46858,445507,991349,873979,885807,889719,450912,36192,490821,346930,115969,690919,214657,165371,1004305,58345,322187,363468,745877,952605,373875,190308,811886,879370,184792,915611,1027076,520646,368178,797543,774638,773576,838191,923119,908839,410866,911608,130595,308220,813933,104091,715832,790951,802320,796754,602487,949635,489470,288435,341929,684988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]