SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435101 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435101 [ RunTime:0.003366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405120,607257,767041,697353,129866,386763,600080,100437,987500,355051,29805,824500,518659,17808,878058,787207,213703,787028,351140,811518,369748,241849,632654,581318,944689,14764,1044750,57852,707472,173351,844352,38695,615348,571038,985993,467301,624993,813855,481308,587635,348103,867100,818538,760855,248185,645925,399396,686609,956775,237348,896021,362138,538099,493278,246450,556917,692656,992821,660152,106915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]