SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251781 LIMIT 1 [ RunTime:0.001728s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251781 [ RunTime:0.004647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324675,141025,36748,431094,252063,731883,834108,53822,101706,794228,940895,212971,820756,754758,613328,945544,962764,696412,284257,770136,421050,170915,862296,1001009,481949,255373,179300,88130,214732,881346,801285,570317,661138,441539,675502,485453,658381,314883,682463,953271,899987,948317,528194,368715,841476,415203,571073,878511,960797,450023,107879,866486,1048353,89168,251812,399263,526845,517413,351692,810503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]