SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516957 LIMIT 1 [ RunTime:0.004150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516957 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306427,386894,394294,105019,206785,885039,1047529,112597,688310,1008475,987177,542653,449903,129190,953662,521152,321047,441494,145019,698770,513849,899753,134363,674248,586587,978056,698080,117981,80258,774766,762483,960428,649754,893504,645261,136336,636342,766385,394857,759713,603914,624673,819990,676795,441013,18523,394052,250623,799800,149277,710760,449097,756215,757536,547039,155209,1036567,1029060,609224,556900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]