SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450649 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450649 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033364,461773,888327,133350,842480,440,755875,508242,760534,380070,190848,589232,229373,627391,507036,262523,588891,356737,604650,746629,327051,878682,325652,732233,501863,1029531,1014651,598191,808114,1011912,923235,150950,368359,929998,873633,454229,965361,827191,29613,527139,426156,663646,594455,562243,697873,987515,694047,20586,564754,525860,305299,199658,98152,500471,617234,169277,767886,61410,714112,475589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]