SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421499 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421499 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850523,46847,265985,102682,282467,129593,1032676,505273,556669,551425,695398,290727,780675,598033,831390,537370,1011665,631170,985217,552235,244276,109275,991362,86076,778894,737284,645033,209311,784052,23773,672572,906318,64591,740560,1042480,438805,530396,339000,81544,79386,238152,395126,377470,859255,432364,912746,1004398,246384,749083,52593,626293,950500,909794,880152,1019733,496962,288126,925300,498569,1040104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]