SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402555 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402555 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744392,940664,921692,766162,415680,554397,58867,468201,539371,705602,391690,187343,204705,1047846,405922,429232,377727,34171,256799,435014,152906,109317,652298,197782,742536,1037159,403137,398417,594679,231812,561119,1041457,961110,132945,875394,491195,553689,402760,647413,739357,600755,434356,693806,708379,304750,736832,732719,310853,518842,70457,758445,885626,658014,440064,11889,345250,547746,397510,300668,559727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]