SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417697 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417697 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025058,939142,22349,744588,454746,774368,826208,191250,337142,612267,762671,391151,204720,891456,854682,947764,113138,833752,899829,182428,684617,964258,882981,725665,10182,528262,517113,343167,111600,620396,358946,93943,561445,1006689,267001,13928,129979,972632,389513,43104,850658,143594,470137,150404,615482,85293,856270,503065,153950,41569,610773,1036316,454813,935325,426743,371704,714188,161226,665156,253325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]