SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293174 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293174 [ RunTime:0.004278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035153,1040623,386819,795525,410150,834835,941988,329156,801512,449842,280486,677368,610626,274367,883620,167243,190925,955689,515948,478963,478891,140369,951318,810014,819538,701003,738899,131622,2920,192911,956953,82524,346957,773709,227421,72980,208235,332076,516858,471339,988617,148344,972662,550366,828209,248886,618886,939609,310263,554454,64212,481949,606051,410499,729906,1048536,408464,677641,712642,216834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]