SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394133 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394133 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331045,151013,216779,189868,1028654,231521,665995,97343,813707,756288,1019471,748040,1017890,295845,217578,101935,983553,897123,73986,301528,83136,1002138,248784,518010,678173,831671,116803,153644,6186,538310,711355,365378,808172,259846,1622,182442,217684,415203,638576,352804,951826,518746,692971,815707,478666,436614,1030666,862599,529189,384247,200276,563447,617200,683328,106160,797298,808671,532057,566808,674490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]