SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457946 LIMIT 1 [ RunTime:0.002314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457946 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391205,596899,343341,1032769,605757,1016321,958274,557478,350931,621853,725763,705029,737435,175452,862210,97534,166631,174856,941536,252466,72800,845339,464828,42612,284439,334178,235287,820173,373558,203885,281442,1027483,905195,359348,404929,716720,1045715,11758,38496,921420,241864,741355,576139,362562,988462,73076,252905,389319,41672,986310,1025163,902967,627761,789576,194637,867024,333726,158030,165723,830149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]