SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43178 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43178 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249234,69266,239990,890114,1021260,171060,847197,944631,85501,215362,613642,209744,810925,119753,634,405101,533114,213756,987098,631380,505488,1025304,54975,647746,835483,732611,532010,466614,116597,4325,47880,104902,817622,875331,755805,722534,453078,536803,420721,91238,601604,662918,177193,757987,97265,331933,396541,416917,639365,632656,6809,359542,522573,388034,394225,368721,899783,460442,618359,481211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]