SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414236 LIMIT 1 [ RunTime:0.004965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414236 [ RunTime:0.003887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223023,675141,238343,813292,815890,981264,400986,897893,383863,161401,978232,138505,677145,600342,105520,131290,631741,372157,746361,300596,397805,428162,690066,478456,149107,998772,291435,1010518,938712,673528,873407,740726,91973,536918,379672,475895,886845,47948,327327,333064,188633,165517,185979,494399,817803,471874,32222,716490,680481,803554,432636,66888,458133,879769,329186,174393,308876,167913,681425,138659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]