SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299618 LIMIT 1 [ RunTime:0.003689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299618 [ RunTime:0.004882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407009,473280,498253,871042,781310,318580,720395,19084,3779,354457,186893,972645,577697,1027694,1032435,23171,794129,483397,365474,434892,913431,206035,908679,15701,47169,638760,970875,834090,768191,730210,381509,741828,964273,318833,1021860,766018,1027282,778578,416221,201379,469593,368967,986307,882473,638462,380385,494114,259093,882297,21205,304130,331039,484522,613211,583264,294260,926500,995630,386992,274679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]