SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503886 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503886 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971266,1015329,456697,970739,643830,901173,76996,732991,990171,389941,743201,136925,492167,412608,23445,444962,501062,431489,198144,951621,332040,1002328,893862,735073,962285,898527,734945,731687,311386,358686,143160,293669,832395,908871,637211,643179,893049,550455,515704,217390,184279,977619,255742,125164,791405,613734,672317,120880,12975,1044215,862278,548668,823512,163236,849953,195190,176633,286502,686776,99315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]