SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474458 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474458 [ RunTime:0.002940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255191,779362,1016133,990529,331438,1037713,512020,1016899,746902,780704,439756,572399,408498,173117,793310,458291,726627,616329,1019577,819971,449650,809265,992686,273627,253776,1047472,534700,117777,949249,888061,489571,846180,456626,106857,22086,65836,1037735,930689,563819,452868,21376,815850,180160,96612,868583,342418,852892,990667,674383,796254,770068,758980,1029795,935279,685234,368986,241465,848473,309197,151218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]