SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422474 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422474 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702650,384972,87964,96410,875094,1013596,182251,423182,660142,964341,210281,410626,558353,199412,999422,288381,149866,40082,198334,721719,1030131,229815,393979,295372,823447,850129,1038865,333565,283293,456766,732797,429747,672216,253126,526579,904271,953128,596407,940738,990982,244304,131977,418284,1035610,27284,234815,307261,154180,560677,93217,208877,21929,243245,195339,494550,870398,732748,608269,567305,512580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]