SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330048 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330048 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942782,99815,501051,270015,618460,115633,729765,398113,957701,282328,368594,837316,720386,614154,355999,546834,692215,460940,210666,88019,994104,812107,84779,874532,71012,410598,1017394,496119,965722,521810,757936,138360,989020,1035026,941198,736858,317071,18393,657080,502010,1038834,961970,778493,613502,592658,202984,18148,612014,852101,202599,964891,434598,62054,149388,833748,92434,634134,216393,509248,386069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]