SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 638936 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 638936 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54484,596021,878298,358825,49101,71368,565281,258026,708877,566653,281411,310594,568434,675558,212621,263505,412705,230969,832483,665963,764442,675398,794443,49449,29836,265263,526092,142688,736400,420208,300920,87290,676940,53287,191511,74488,345917,194118,864590,595287,533554,892478,317870,318058,180210,783502,911161,123180,204094,275935,11076,92519,84842,644387,1016123,837491,598376,57064,180699,364482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 638936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 638936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]