SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022303 LIMIT 1 [ RunTime:0.004847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022303 [ RunTime:0.005812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034280,1035905,413544,676883,761151,1026700,130776,800262,876170,283498,756955,1004806,156440,634950,1004988,834320,396197,544675,49635,98280,587640,933087,83313,626542,454315,581275,124688,452869,535245,263756,477296,63058,294885,161591,362254,556560,228320,321573,977508,670914,55555,175848,717330,229486,776653,466136,511882,935408,9340,439611,1042154,405394,947244,572837,491528,338352,280134,404435,224018,284796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]