SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804648 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804648 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451583,212334,347412,191450,357958,78540,4089,128393,285485,370790,556311,682855,344551,424219,61937,984570,251051,130421,251290,834668,276400,700465,396522,1024412,563976,191884,93774,13965,742146,413975,271819,30381,973290,373041,953539,205319,333387,266214,307962,292456,357278,589097,120466,948823,493724,890155,547118,597993,612470,545283,1002980,731124,467293,1023322,142974,806641,702649,586558,50828,885266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]