SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44511 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44511 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237501,839449,1020281,846739,444221,994667,854486,363853,190725,787220,587509,842184,966169,11468,793494,796300,987087,267990,26354,785934,765807,751593,103537,391947,526436,352720,441718,673563,871977,188624,630215,744957,654947,450411,569116,608755,829658,794806,41460,1048618,347266,55784,617288,532354,631731,362212,278575,218345,617279,411981,806984,749962,708965,866710,534710,920422,966201,1005536,491084,831405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]