SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020566 LIMIT 1 [ RunTime:0.001488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020566 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508164,691767,224264,726792,1041249,641069,818212,207525,287219,521736,63718,823487,907077,816503,410932,1046040,960342,585423,918573,395752,467440,546849,960517,316169,920062,395825,750552,439910,1019168,765456,813704,357824,878035,577493,766140,748516,981624,358462,91889,259937,626021,488740,140692,891101,518982,668840,78408,833629,958120,1045284,972779,828229,62537,102477,79954,390058,265558,599050,781125,894679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]