SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40190 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40190 [ RunTime:0.001397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159061,403006,316121,747672,815626,604834,364249,591752,306599,617263,178450,621035,537676,40712,478332,741685,703621,477088,656186,569590,554423,247303,294860,525260,803598,426273,523433,360930,863591,538557,522714,427047,996495,256745,440901,440307,913785,22586,494311,516586,342551,775769,857145,138824,200331,432552,606111,384201,109869,63376,160059,89439,765543,1042692,139197,420240,115309,503318,831820,196083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]