SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417609 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417609 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712404,840128,427748,424540,827815,773726,742148,22736,621596,234249,569525,340890,430618,384793,927204,805064,351668,11736,130060,901523,885371,783793,955495,19688,117508,294995,612581,100749,518689,836198,167829,301169,45035,615924,914156,1017266,202416,737962,419573,882453,720162,681084,747788,68897,563374,101807,456291,942856,831094,168470,535539,338174,141968,688534,938568,690319,197971,785519,261431,859890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]