SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107984 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107984 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133550,525010,120449,281191,77539,277294,624400,745235,348003,983599,788717,499457,28073,847408,859065,347408,170012,584096,352508,388053,246096,709804,455730,809437,863383,889469,158881,739039,557937,950716,200582,446629,993172,358953,937651,122532,377301,142040,680872,635310,37777,918718,226043,1011292,58476,770129,181071,505554,865126,678618,109302,825730,329675,791280,223144,293829,770766,980554,990695,422047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]