SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418742 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418742 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39663,779245,840108,286596,454411,421576,884777,427118,463455,769656,195066,716897,599573,175944,237755,1043890,774157,275430,290327,240039,453636,624743,327055,887772,240023,929184,457530,761721,755732,388444,665337,807977,1031500,90378,486644,543057,778273,931857,473442,52534,398465,679545,300808,16771,696390,474739,623865,946738,991629,773842,813731,758738,625282,63249,522690,815061,487720,570454,304252,151034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]