SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22410 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22410 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132814,922562,442928,669493,706742,80743,791248,87059,619996,366442,564912,404806,591401,358804,391397,383419,112836,889655,677842,269810,655445,451513,859378,345545,405986,499859,252149,135093,903962,728413,966197,572962,905723,526416,937126,204324,666903,63182,103524,112998,233248,761422,237418,510599,263948,856319,607100,823122,395184,874175,558689,8761,808677,493209,281892,122570,253026,927694,275543,816754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]