SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568212 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568212 [ RunTime:0.003608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722281,1032889,844584,36803,565995,477238,823406,421444,1029714,353993,790022,756713,716409,277227,661723,1009819,267183,223906,322776,956962,629500,78002,180976,678338,96422,623366,698243,809159,508132,38727,656098,419345,904327,271106,26372,198491,281917,588799,739226,405331,941434,754674,584803,1000061,212354,218793,1033027,541321,63476,689083,505161,864486,348365,676855,586108,426644,414932,963385,818476,558780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]