SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020597 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020597 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562661,712481,881745,207618,214642,452312,412045,414847,581956,832541,695718,60797,145079,161296,974813,180647,302530,1002675,956621,865636,456967,771646,204938,887105,405383,1035230,251363,255387,43317,896570,530321,441431,904347,110676,924351,654604,253158,993456,254644,213292,51035,808283,688681,831897,947664,562013,136502,49249,843830,85208,33862,98130,793905,271633,854235,628705,65728,846240,616352,128130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001237s ]