SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477813 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477813 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924855,13693,178307,926461,213357,77256,661655,22104,28373,673694,545164,591613,475038,535244,756417,285074,511846,41114,638013,779688,731048,862079,759693,112140,90325,500353,352969,583416,994487,1043923,271011,875464,197195,1021167,590118,318693,632915,522152,71235,613511,454930,315830,673771,388253,423509,597480,133391,273848,738455,436472,89959,799929,142516,753263,857435,134564,478408,812278,569022,884996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]