SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485110 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485110 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401530,861903,396937,570260,588159,522469,255389,143844,74715,882289,298978,297354,252523,394252,757208,641161,1026731,731605,684,596926,1000954,249938,8323,709311,152316,672544,786608,1020395,458413,311232,575266,395589,424841,346073,864760,684748,1028304,135428,556093,545517,795436,656840,607451,674318,166326,225835,970121,64281,429320,768965,499282,708239,844894,13317,354880,899484,973476,702585,704124,466570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001083s ]