SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103906 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103906 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651520,924601,7457,893336,332996,180338,1026939,611637,968012,24802,618915,1002000,295425,926609,263212,210260,141709,485812,977094,492295,696615,626061,520932,634678,39373,498662,375430,216638,298271,545335,984816,596874,387889,367703,956181,520020,535535,629379,591910,138285,807598,189114,736787,719037,163173,689334,547274,37424,321968,84696,853390,371134,1002330,237566,288464,469048,821307,369459,956861,889666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]