SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455460 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455460 [ RunTime:0.001426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523305,591603,617282,420855,450870,619297,131912,879147,714811,620290,267181,297542,520666,154725,286749,54537,563936,248359,133930,549499,2191,876771,388171,659548,239292,484350,148056,755756,774682,41395,610418,61115,214189,1011030,912461,909918,9665,555143,81518,704470,363173,772447,11422,417104,214936,252173,206454,1000828,1014995,794655,720810,540716,294701,313758,461425,626007,275711,494210,474854,92223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]