SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54498 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54498 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68389,956734,67631,529383,373157,490618,34059,458041,241681,192770,214210,771109,7901,654641,1025805,79765,128287,234624,853143,969207,417527,354320,452440,359849,888656,842038,935950,616234,421279,1001600,810216,106444,718490,152554,578824,580328,762192,440812,585682,39188,143688,772679,394929,399086,659845,501200,250167,940615,446447,578324,22636,366289,332102,1014106,1027815,460292,327443,305267,4970,737440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]