SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001861 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001861 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580021,303847,232521,918901,609080,25072,297721,456231,787627,443882,288560,33082,241687,541222,36233,172110,888659,896971,441348,198399,494014,406290,475501,451580,731352,181337,879746,720851,933796,972052,1031777,819625,371438,525628,640830,95319,456515,499490,579471,383820,721501,347124,590199,70936,398664,53763,546446,750468,731713,623917,554371,569847,43553,494951,458458,939779,414146,365070,518587,615313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]