SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497909 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497909 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420851,481556,438715,621471,985179,406675,382926,693113,771255,547666,882228,255490,267332,25929,251918,506105,359123,777500,289433,149943,117733,987226,394924,79240,50332,485901,507819,824835,676674,607148,41707,484391,228740,127716,520274,433722,775411,511016,610568,77341,204276,61882,229071,724326,632218,985117,846237,528662,430525,460442,212216,984016,73243,954829,248323,384229,184176,555432,767351,22376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]