SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316085 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316085 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871366,18911,422118,948109,612850,1014840,214140,949834,1025373,556429,415811,786453,964285,562646,193251,172955,270344,924818,623452,992880,980858,222248,801235,83777,393650,254373,436168,283512,325512,922201,452019,198709,933176,542113,620395,953085,1048921,686156,937489,800508,267896,867977,277504,75102,653354,648187,85252,973891,759549,546237,472878,147724,740926,115765,220637,994908,507760,1028702,154983,772593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]