SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251036 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251036 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687240,347855,64997,543307,160991,852172,897966,237718,922758,848060,953874,100271,281639,613388,385944,1018569,39873,630729,444669,678643,362941,1017411,444454,833034,191972,283691,986062,414386,607495,188686,958433,548777,321258,449826,806561,557603,707651,163502,616138,359187,988258,645507,908783,735030,97353,353481,323146,434916,425997,546977,190274,307967,968324,683150,370174,404048,990620,627175,80365,781004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]