SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295214 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295214 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121267,157532,42453,466753,48867,510649,205877,398707,704071,626425,828866,238598,940714,608303,1025907,81742,387834,239849,157889,372860,398771,319843,340965,348292,937293,795296,584083,835715,758217,194599,297662,966360,621832,767947,26726,568834,294819,767720,175840,682736,1056,153245,357087,326153,710933,696619,764513,610500,535579,723055,652605,333371,856810,250046,176582,646486,494681,461211,44164,110307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]