SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53661 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53661 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907850,671594,104912,421658,911386,558880,736011,899411,266055,484104,693428,420489,811760,77891,664987,948568,33345,174154,914309,238543,146875,512303,5899,99398,1023641,460238,234690,68926,161280,361179,797831,351941,638410,782842,436073,651664,926415,441560,42567,140822,404147,101394,606560,1011585,761531,968586,521462,175318,661123,691607,838120,2069,952252,1032558,736028,39139,390992,830164,405059,733616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]