SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020415 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020415 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187979,671296,17272,806246,748396,951558,640559,82831,155625,77655,327481,768664,553258,877592,777410,394267,20398,363890,988696,296230,526518,181690,42288,317900,1041265,76309,391766,132687,343750,337764,109219,933242,142511,351018,49440,652098,241085,392045,278204,689531,842303,454915,957294,678695,882542,487267,166775,604856,538359,222655,385534,627549,630067,896778,973184,270851,36186,84760,581553,122039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]