SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104085 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104085 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638559,420327,510959,822891,573548,254789,106784,1001168,394317,386956,198052,690380,696615,659723,426448,52410,880385,839441,691306,172684,996301,212666,903468,31062,154110,239554,332921,48339,384545,843686,335177,267701,388718,877603,756098,780542,214130,825444,446961,85603,641049,553335,776582,1039897,624288,1048189,1028832,724180,924857,808207,705690,300895,454958,745957,161061,126402,533289,420956,771576,151914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001341s ]