SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103216 LIMIT 1 [ RunTime:0.000719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103216 [ RunTime:0.006091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105635,461124,841416,715216,811008,246059,1002452,279952,574661,722630,343951,824137,930356,847543,964302,724842,165509,935771,1009192,59067,836912,872728,512834,478099,778794,867431,39348,725578,1650,731433,839091,795435,312054,340840,644518,902902,302185,384684,984289,113827,270529,687682,552136,108193,918390,429830,405441,12236,216274,856669,603058,848155,683652,717310,411232,33770,293915,371504,794990,340821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]