SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465746 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465746 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553081,380360,368986,576113,881909,934984,689252,359394,329015,55661,295209,129457,162780,190118,298009,966638,48221,7638,706121,944990,110261,447135,910601,240206,166153,997630,865452,417756,573896,140891,393355,857514,827450,1043770,698867,426805,550566,588897,744477,427880,839939,611697,193783,766380,245459,340228,910578,984982,661157,223647,732239,433170,506797,905516,602056,727206,60640,737378,143391,335350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001562s ]