SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458544 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458544 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268055,96905,560164,730917,112527,386310,170821,311853,1037713,39634,172209,47994,868609,974008,940406,681691,713632,230747,946105,747710,256850,651724,732793,782896,289,241487,489092,1001764,97861,989127,944829,787367,364731,243771,697444,126165,825118,501308,284094,717860,1025977,411399,40418,541410,428017,614339,261417,13415,414135,735178,932937,252882,592900,832588,194170,886243,479242,234505,176182,954321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]