SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575057 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575057 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919962,516567,380865,867081,836478,475671,499175,69561,891612,429314,768773,305703,653252,931224,861446,75199,452420,622887,923585,795167,683147,302910,920741,342389,138180,403837,948364,677105,105257,283813,111530,485609,292235,56900,1027506,71797,640796,520747,480066,44088,625689,955694,384598,375238,660500,53382,1024159,631904,276916,258241,141781,124635,337165,807209,741200,362056,45063,704712,374332,97667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]