SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023484 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023484 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706675,418288,413038,388133,53481,439011,400045,998055,206591,847282,709160,387413,719888,1043277,766583,108595,174932,1023068,408603,805411,10399,719489,739496,87584,689718,560522,637816,810334,131393,59505,139240,1011484,862188,850860,771083,652392,558614,944391,683234,426272,473277,880816,984390,399373,979214,153313,833223,790490,601250,447802,739487,132352,975093,2149,261867,167780,677550,311877,383610,171583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]