SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105733 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105733 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114661,486906,967579,320843,16433,781047,941421,27845,451364,522699,500579,434103,268319,855091,961546,370352,96627,571411,843995,839775,794985,803935,4445,417160,841936,272542,950681,118179,776427,919084,602062,745992,109655,350842,340677,225687,279591,293360,527755,796120,226483,86160,985538,620995,749692,946948,407572,822226,962482,936031,708788,477253,885540,787706,702543,612460,436683,1026731,262590,942787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]