SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518743 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518743 [ RunTime:0.003973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544965,876739,82000,323697,1026821,190794,742857,180835,129943,314320,93983,592264,802099,909677,846570,866406,640782,261341,353442,309798,1037202,175342,160624,850925,155667,173942,150822,949421,403065,265468,832489,649091,788906,633898,933607,329336,386292,157419,619113,354395,927434,620690,772208,101386,849850,870094,756766,337264,765158,797556,107627,218221,952180,871989,111278,727350,847416,847123,472090,111610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001123s ]