SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331112 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331112 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145926,922379,714059,616598,992515,338933,732594,555050,780072,818375,195133,859873,816027,236208,857836,193756,290619,625610,528465,189468,419115,708702,376011,237168,638320,894112,147998,375699,301717,587452,334346,612139,844533,762884,523535,800167,876558,832550,304082,1025670,756474,245193,833837,591779,31384,750697,155877,127144,440981,412584,717217,211597,49510,112800,391033,849843,140772,1026949,624615,440071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]