SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543691 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543691 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118210,413874,953249,840592,758696,360531,975928,935285,528368,623538,1040413,840069,222817,224588,56855,425726,809433,860288,831436,484797,974749,1034267,469476,723242,129543,924477,145962,496673,173459,699954,211834,879894,879565,982885,503129,761984,4928,777473,748271,103799,421842,99112,815875,3799,435397,366372,422271,325595,365555,356293,1005615,266469,394754,647073,687218,619835,728975,690332,777732,792453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]