SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49883 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49883 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86326,935783,5999,579903,764988,560640,1030707,1028084,699884,502098,945861,34935,866028,689695,105258,684404,370853,903165,618141,574859,607230,19969,51180,319459,569675,603579,1027202,442856,231442,272914,969368,3185,705870,32975,658467,198828,123103,555385,482280,380610,876355,851232,104074,111325,697176,451602,771641,291901,817693,263430,939652,358717,7019,69434,814909,269164,70620,1026135,10171,395259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]