SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31146 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31146 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036280,50430,370902,1027485,727104,13401,880376,614300,35042,791076,819954,479425,249720,823802,166593,671804,543434,370572,659704,571849,536636,860386,507498,415498,62862,165005,819260,254550,126634,272237,810420,795423,998505,566724,877625,426955,120149,496285,797391,742962,959653,938291,121030,120888,902246,468077,67076,225662,440512,411944,208650,609274,670320,293378,636180,474977,458049,492620,634755,935284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000772s ]